Returns an expression formatted as a date or time.
|
|---|
FormatDateTime(Date[, NamedFormat]) |
Arguments
-
Date
-
Required. Date expression to be formatted.
-
NamedFormat
-
Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.
Settings
The NamedFormat argument has the following settings:
|
Constant
|
Value
|
Description
|
|
vbGeneralDate
|
0
|
Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.
|
|
vbLongDate
|
1
|
Display a date using the long date format specified in your computer's regional settings.
|
|
vbShortDate
|
2
|
Display a date using the short date format specified in your computer's regional settings.
|
|
vbLongTime
|
3
|
Display a time using the time format specified in your computer's regional settings.
|
|
vbShortTime
|
4
|
Display a time using the 24-hour format (hh:mm).
|
Remarks
Requirements
See Also
 
